| Original Column Name |
Expanded Column Name |
Description |
| ContactEntryHisID |
Contact Entry History Identifier |
A unique identifier for each historical record of a contact entry in the EHR system. |
| AppearOrder |
Appearance Order |
The sequential order in which the contact entries appear in the EHR system. |
| ContactID |
Contact Identifier |
The unique identifier for a contact within the EHR system. |
| ContactTypeID |
Contact Type Identifier |
A code or number that identifies the type of contact, such as patient, physician, insurance company, etc. |
| DateFrom |
Date From |
The start date for the period in which the contact entry is considered active or relevant. |
| DateInact |
Date Inactive |
The date on which the contact entry was marked as inactive in the EHR system. |
| DateTo |
Date To |
The end date for the period in which the contact entry is considered active or relevant. |
| IsActive |
Is Active |
A Boolean value indicating whether the contact entry is currently active. |
| IsActiveDate |
Active Status Change Date |
The date on which the active status of the contact entry last changed. |
| Notes |
Notes |
Additional information or commentary about the contact entry. |
| RecptID |
Recipient Identifier |
The unique identifier for the entity (e.g., a patient or a department) that is the recipient of the contact entry. |
| RecptTypeID |
Recipient Type Identifier |
A code or number that specifies the type of the recipient, such as an individual patient, a healthcare provider, or an organization. |
| RelationshipID |
Relationship Identifier |
A unique identifier that denotes the relationship between the contact and the recipient within the EHR system. |
| VendorID |
Vendor Identifier |
The unique identifier for the vendor associated with the contact entry. |
| ZUChkSum |
ZU Checksum |
An audit trail checksum used to verify the integrity of the contact entry history data for security and audit purposes. |
| ZUDate |
ZU Date |
The date associated with the audit log record for the contact entry history within the EHR system. |
| ZULogonHisID |
ZU Logon History Identifier |
An identifier for an entry in the audit log history that correlates with a user logon event. |
| Unnamed: 17 |
Unnamed: Column 17 |
Unlabeled or unrecognized column in the data set; content and purpose are unknown. |
| EMail |
Email |
The electronic mail address associated with the contact entry. |
| ContactTypeName |
Contact Type Name |
The descriptive name corresponding to the Contact Type Identifier, clarifying the type of contact (e.g., 'Primary Care Physician'). |
| Unnamed: 20 |
Unnamed: Column 20 |
Unlabeled or unrecognized column in the data set; content and purpose are unknown. |
| RelationshipName |
Relationship Name |
The descriptive name that corresponds to the Relationship Identifier, explaining the relationship (e.g., 'Emergency Contact'). |